/*
 Navicat Premium Data Transfer

 Source Server         : 公司运服务器
 Source Server Type    : SQL Server
 Source Server Version : 13005026
 Source Host           : www.shanghaibuda.com:1433
 Source Catalog        : scm_main_dev
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 13005026
 File Encoding         : 65001

 Date: 27/05/2020 14:15:50
*/


-- ----------------------------
-- Table structure for bd_schedule_receive
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[bd_schedule_receive]') AND type IN ('U'))
	DROP TABLE [dbo].[bd_schedule_receive]
GO

CREATE TABLE [dbo].[bd_schedule_receive] (
  [id] bigint  IDENTITY(1,1) NOT NULL,
  [user_no] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [user_name] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [rq] varchar(7) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [d1] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [d2] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [d3] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [d4] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [d5] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [d6] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [d7] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [d8] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [d9] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [d10] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [d11] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [d12] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [d13] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [d14] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [d15] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [d16] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [d17] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [d18] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [d19] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [d20] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [d21] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [d22] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [d23] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [d24] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [d25] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [d26] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [d27] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [d28] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [d29] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [d30] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [d31] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [bh] varchar(20) COLLATE Chinese_PRC_CI_AS  NOT NULL
)
GO

ALTER TABLE [dbo].[bd_schedule_receive] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Primary Key structure for table bd_schedule_receive
-- ----------------------------
ALTER TABLE [dbo].[bd_schedule_receive] ADD CONSTRAINT [PK__bd_sched__5162BB9F07B683A6] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO

